Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Is Public Domain, Object Name, Title, Culture, Artist Role, Artist Display Name, Artist Nationality, Object Date, Object Begin Date, Object End Date, Medium, Dimensions, Credit Line
Link | rowid ▼ | Object Number | Is Highlight | Is Public Domain | Object ID | Department | Object Name | Title | Culture | Period | Dynasty | Reign | Portfolio | Artist Role | Artist Prefix | Artist Display Name | Artist Display Bio | Artist Suffix | Artist Alpha Sort | Artist Nationality | Artist Begin Date | Artist End Date | Object Date | Object Begin Date | Object End Date | Medium | Dimensions | Credit Line | Geography Type | City | State | County | Country | Region | Subregion | Locale | Locus | Excavation | River | Classification | Rights and Reproduction | Link Resource | Metadata Date | Repository |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
100324 | 100324 | 94.4.56a, b | 0 | 1 | 187697 | European Sculpture and Decorative Arts 3 | Teapot 26 | Teapot | Danish, Copenhagen 2273 | Factory 328 | Royal Porcelain Manufactory | Danish, 1775–present | Royal Porcelain Manufactory 8169 | Danish 144 | 1775 | 9999 | 19th century | 1800 | 1899 | Hard-paste porcelain 572 | Height: 5 1/4 in. (13.3 cm) | Gift of Henry G. Marquand, 1894 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/187697 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
100325 | 100325 | 94.4.57a, b | 0 | 1 | 187698 | European Sculpture and Decorative Arts 3 | Teapot 26 | Teapot | Danish, Copenhagen 2273 | Factory 328 | Royal Porcelain Manufactory | Danish, 1775–present | Royal Porcelain Manufactory 8169 | Danish 144 | 1775 | 9999 | 19th century | 1800 | 1899 | Hard-paste porcelain 572 | Height: 3 in. (7.6 cm) | Gift of Henry G. Marquand, 1894 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/187698 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
100326 | 100326 | 94.4.58a, b | 0 | 1 | 187699 | European Sculpture and Decorative Arts 3 | Tea caddy 282 | Tea caddy | Danish, Copenhagen 2273 | Factory 328 | Royal Porcelain Manufactory | Danish, 1775–present | Royal Porcelain Manufactory 8169 | Danish 144 | 1775 | 9999 | 19th century | 1800 | 1899 | Hard-paste porcelain 572 | Height: 4 1/2 in. (11.4 cm) | Gift of Henry G. Marquand, 1894 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/187699 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
100327 | 100327 | 94.4.59a, b | 0 | 1 | 187700 | European Sculpture and Decorative Arts 3 | Cup and saucer 285 | Cup and saucer | Danish, Copenhagen 2273 | Factory 328 | Royal Porcelain Manufactory | Danish, 1775–present | Royal Porcelain Manufactory 8169 | Danish 144 | 1775 | 9999 | 19th century | 1800 | 1899 | Hard-paste porcelain 572 | Overall (Cup): 2 1/2 × 2 in. (6.4 × 5.1 cm); Diameter (Saucer): 4 1/2 in. (11.4 cm) | Gift of Henry G. Marquand, 1894 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/187700 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
101365 | 101365 | 04.6.1a, b, .2a, b | 0 | 1 | 188876 | European Sculpture and Decorative Arts 3 | Vases 4454 | Pair of vases | Danish, Copenhagen 2273 | Factory 328 | Royal Porcelain Manufactory | Danish, 1775–present | Royal Porcelain Manufactory 8169 | Danish 144 | 1775 | 9999 | 1880–90 | 1880 | 1890 | Hard-paste porcelain 572 | Height (each): 15 in. (38.1 cm) | The F.O. Matthiessen Collection, Gift of Mrs. Emma Matthiessen, in memory of her husband, 1904 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/188876 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
101495 | 101495 | 06.369a, b | 0 | 1 | 189009 | European Sculpture and Decorative Arts 3 | Cup and saucer 285 | Cup and saucer | Italian, Naples 427 | Manufactory 331 | Royal Porcelain Manufactory, Naples | Royal Porcelain Manufactory 8169 | Italian 6 | 18th century | 1700 | 1799 | Soft-paste porcelain 2061 | Height (cup .369a): 2 1/2 in. (6.4 cm); Diameter (saucer .369b): 5 3/8 in. (13.7 cm) | Rogers Fund, 1906 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/189009 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
110117 | 110117 | 38.145.200 | 0 | 0 | 198228 | European Sculpture and Decorative Arts 3 | Medallion 72 | King George I of Greece | Danish, Copenhagen 2273 | Factory 328 | Royal Porcelain Manufactory | Danish, 1775–present | Royal Porcelain Manufactory 8169 | Danish 144 | 1775 | 9999 | ca. 1927 | 1922 | 1932 | Hard-paste porcelain 572 | 5 × 3 1/2 in. (12.7 × 8.9 cm) | Bequest of Mary Martin, 1938 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/198228 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
110119 | 110119 | 38.145.203 | 0 | 0 | 198230 | European Sculpture and Decorative Arts 3 | Medallion 72 | Dagmar, Dowager Empress (1847–1927) | Danish, Copenhagen 2273 | Factory 328 | Royal Porcelain Manufactory | Danish, 1775–present | Royal Porcelain Manufactory 8169 | Danish 144 | 1775 | 9999 | 20th century | 1900 | 1999 | Hard-paste porcelain 572 | 4 3/4 × 3 1/2 in. (12.1 × 8.9 cm) | Bequest of Mary Martin, 1938 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/198230 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
110120 | 110120 | 38.145.204 | 0 | 0 | 198231 | European Sculpture and Decorative Arts 3 | Medallion 72 | Queen Louise (1817–1898) | Danish, Copenhagen 2273 | Factory 328 | Royal Porcelain Manufactory | Danish, 1775–present | Royal Porcelain Manufactory 8169 | Danish 144 | 1775 | 9999 | 20th century | 1900 | 1999 | Hard-paste porcelain 572 | 5 × 3 1/2 in. (12.7 × 8.9 cm) | Bequest of Mary Martin, 1938 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/198231 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
110121 | 110121 | 38.145.205 | 0 | 0 | 198232 | European Sculpture and Decorative Arts 3 | Medallion 72 | King Frederick VIII (1843–1912) | Danish, Copenhagen 2273 | Factory 328 | Royal Porcelain Manufactory | Danish, 1775–present | Royal Porcelain Manufactory 8169 | Danish 144 | 1775 | 9999 | 20th century | 1900 | 1999 | Hard-paste porcelain 572 | 5 × 3 1/2 in. (12.7 × 8.9 cm) | Bequest of Mary Martin, 1938 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/198232 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
110122 | 110122 | 38.145.206 | 0 | 0 | 198233 | European Sculpture and Decorative Arts 3 | Medallion 72 | King Christian IX (1818–1906) | Danish, Copenhagen 2273 | Factory 328 | Royal Porcelain Manufactory | Danish, 1775–present | Royal Porcelain Manufactory 8169 | Danish 144 | 1775 | 9999 | 20th century | 1900 | 1999 | Hard-paste porcelain 572 | 5 × 3 1/2 in. (12.7 × 8.9 cm) | Bequest of Mary Martin, 1938 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/198233 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
110123 | 110123 | 38.145.207 | 0 | 0 | 198234 | European Sculpture and Decorative Arts 3 | Medallion 72 | Queen Alexandra (1844–1925) | Danish, Copenhagen 2273 | Factory 328 | Royal Porcelain Manufactory | Danish, 1775–present | Royal Porcelain Manufactory 8169 | Danish 144 | 1775 | 9999 | 20th century | 1900 | 1999 | Hard-paste porcelain 572 | 4 7/8 × 3 1/2 in. (12.4 × 8.9 cm) | Bequest of Mary Martin, 1938 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/198234 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
110124 | 110124 | 38.145.208 | 0 | 0 | 198235 | European Sculpture and Decorative Arts 3 | Medallion 72 | Marie, Princess of Orléans (1865–1909) | Danish, Copenhagen 2273 | Factory 328 | Royal Porcelain Manufactory | Danish, 1775–present | Royal Porcelain Manufactory 8169 | Danish 144 | 1775 | 9999 | 20th century | 1900 | 1999 | Hard-paste porcelain 572 | 5 × 3 1/2 in. (12.7 × 8.9 cm) | Bequest of Mary Martin, 1938 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/198235 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
110128 | 110128 | 38.145.210 | 0 | 0 | 198239 | European Sculpture and Decorative Arts 3 | Medallion 72 | Queen Louise (1851–1926) | Danish, Copenhagen 2273 | Factory 328 | Royal Porcelain Manufactory | Danish, 1775–present | Royal Porcelain Manufactory 8169 | Danish 144 | 1775 | 9999 | 20th century | 1900 | 1999 | Hard-paste porcelain 572 | 4 7/8 × 3 1/2 in. (12.4 × 8.9 cm) | Bequest of Mary Martin, 1938 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/198239 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
111092 | 111092 | 43.100.3 | 0 | 1 | 199316 | European Sculpture and Decorative Arts 3 | Group 3937 | Cavalier and Sleeping Shepherdess | Danish, Copenhagen 2273 | Factory 328 | Royal Porcelain Manufactory | Danish, 1775–present | Royal Porcelain Manufactory 8169 | Danish 144 | 1775 | 9999 | ca. 1783 | 1778 | 1788 | Hard-paste porcelain 572 | 6 5/8 × 7 1/2 in. (16.8 × 19.1 cm) | Gift of R. Thornton Wilson, in memory of Florence Ellsworth Wilson, 1943 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/199316 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
112468 | 112468 | 50.211.30a, b, .31 | 0 | 1 | 200750 | European Sculpture and Decorative Arts 3 | Custard cup with cover and tray 8028 | Custard cup with cover and tray | Danish, Copenhagen 2273 | Factory 328 | Royal Porcelain Manufactory | Danish, 1775–present | Royal Porcelain Manufactory 8169 | Danish 144 | 1775 | 9999 | 1880–90 | 1880 | 1890 | Hard-paste porcelain 572 | Overall (Cup .30ab): 3 x 3 x 2 3/8 in. (7.6 x 7.6 x 6 cm); Overall (Tray .31): 15/16 x 4 3/16 x 4 3/16 in. (2.4 x 10.6 x 10.6 cm) | Gift of R. Thornton Wilson, in memory of Florence Ellsworth Wilson, 1950 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/200750 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
113495 | 113495 | 54.147.101 | 0 | 1 | 201796 | European Sculpture and Decorative Arts 3 | Dish 110 | Dish | Italian, Naples 427 | Factory 328 | Royal Porcelain Manufactory, Naples | Royal Porcelain Manufactory 8169 | ca. 1745 | 1740 | 1750 | Soft-paste porcelain 2061 | Overall: 1 5/8 × 9 13/16 × 13 in. (4.1 × 24.9 × 33 cm) | Gift of R. Thornton Wilson, in memory of Florence Ellsworth Wilson, 1954 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/201796 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
114812 | 114812 | 64.101.354a–e | 0 | 1 | 203262 | European Sculpture and Decorative Arts 3 | Inkstand 208 | Inkstand | Italian, Naples 427 | Manufactory 331 | Royal Porcelain Manufactory, Naples | Royal Porcelain Manufactory 8169 | Italian 6 | ca. 1765 | 1760 | 1770 | Soft-paste porcelain 2061 | Overall: 8 3/8 × 10 1/8 × 8 in. (21.3 × 25.7 × 20.3 cm) | Gift of Irwin Untermyer, 1964 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/203262 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
116734 | 116734 | 1972.190.1a, b | 0 | 1 | 205476 | European Sculpture and Decorative Arts 3 | Vase with cover 3928 | Vase with cover | Danish, Copenhagen 2273 | Factory 328 | Royal Porcelain Manufactory | Danish, 1775–present | Royal Porcelain Manufactory 8169 | Danish 144 | 1775 | 9999 | ca. 1785 | 1780 | 1790 | Hard-paste porcelain 572 | Height: 10 9/16 in. (26.8 cm) | Gift of the Royal Copenhagen Porcelain Manufactory Ltd., 1972 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/205476 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
116735 | 116735 | 1972.190.2a, b | 0 | 1 | 205477 | European Sculpture and Decorative Arts 3 | Cup and saucer 285 | Cup and saucer | Danish, Copenhagen 2273 | Factory 328 | Royal Porcelain Manufactory | Danish, 1775–present | Royal Porcelain Manufactory 8169 | Danish 144 | 1775 | 9999 | ca. 1785 | 1780 | 1790 | Hard-paste porcelain 572 | Height (Cup): 2 9/16 in. (6.5 cm); Overall (Saucer): 1 1/4 × 5 9/16 in. (3.2 × 14.1 cm) | Gift of the Royal Copenhagen Porcelain Manufactory Ltd., 1972 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/205477 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
117218 | 117218 | 1974.356.537 | 0 | 1 | 206057 | European Sculpture and Decorative Arts 3 | Snuffbox 818 | Snuffbox | Danish, Copenhagen 2273 | Factory 328 | Royal Porcelain Manufactory | Danish, 1775–present | Royal Porcelain Manufactory 8169 | Danish 144 | 1775 | 9999 | ca. 1775–80 | 1770 | 1785 | Hard-paste porcelain, silver gilt 22310 | Length: 3 1/4 in. (8.3 cm) | The Lesley and Emma Sheafer Collection, Bequest of Emma A. Sheafer, 1973 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/206057 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
117956 | 117956 | 1981.412 | 0 | 1 | 206899 | European Sculpture and Decorative Arts 3 | Figure 9 | Hercules Resting from His Labors | Italian, Naples 427 | Manufactory 331 | Attributed to | Royal Porcelain Manufactory, Naples | Royal Porcelain Manufactory 8169 | Italian 6 | ca. 1785–95 | 1780 | 1800 | Hard-paste porcelain 572 | Height: 8 3/4 in. (22.2 cm) | The Charles E. Sampson Memorial Fund, 1981 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/206899 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
118106 | 118106 | 1982.60.208 | 0 | 1 | 207098 | European Sculpture and Decorative Arts 3 | Figure 9 | Goose Seller | Danish, Copenhagen 2273 | Factory 328 | Royal Porcelain Manufactory | Danish, 1775–present | Royal Porcelain Manufactory 8169 | Danish 144 | 1775 | 9999 | ca. 1780 | 1775 | 1785 | Hard-paste porcelain 572 | Height: 6 15/16 in. (17.6 cm) | The Jack and Belle Linsky Collection, 1982 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/207098 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
118107 | 118107 | 1982.60.209 | 0 | 1 | 207099 | European Sculpture and Decorative Arts 3 | Figure 9 | Goose Seller | Danish, Copenhagen 2273 | Factory 328 | Royal Porcelain Manufactory | Danish, 1775–present | Royal Porcelain Manufactory 8169 | Danish 144 | 1775 | 9999 | ca. 1780 | 1775 | 1785 | Hard-paste porcelain 572 | Height: 7 in. (17.8 cm) | The Jack and Belle Linsky Collection, 1982 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/207099 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
118108 | 118108 | 1982.60.210 | 0 | 1 | 207100 | European Sculpture and Decorative Arts 3 | Group 3937 | America | Danish, Copenhagen 2273 | Factory 328 | Royal Porcelain Manufactory | Danish, 1775–present | Royal Porcelain Manufactory 8169 | Danish 144 | 1775 | 9999 | ca. 1780–81 | 1775 | 1786 | Hard-paste porcelain 572 | Height: 6 in. (15.2 cm) | The Jack and Belle Linsky Collection, 1982 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/207100 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
118109 | 118109 | 1982.60.211 | 0 | 1 | 207101 | European Sculpture and Decorative Arts 3 | Group 3937 | Orientals | Danish, Copenhagen 2273 | Factory 328 | Royal Porcelain Manufactory | Danish, 1775–present | Royal Porcelain Manufactory 8169 | Danish 144 | 1775 | 9999 | ca. 1783 | 1778 | 1788 | Hard-paste porcelain 572 | Height: 6 1/8 in. (15.6 cm) | The Jack and Belle Linsky Collection, 1982 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/207101 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
118115 | 118115 | 1982.60.217 | 0 | 1 | 207107 | European Sculpture and Decorative Arts 3 | Group 3937 | Shepherd Couple | Danish, Copenhagen 2273 | Factory 328 | Royal Porcelain Manufactory | Danish, 1775–present | Royal Porcelain Manufactory 8169 | Danish 144 | 1775 | 9999 | ca. 1775–80 | 1770 | 1785 | Hard-paste porcelain 572 | Height: 6 in. (15.2 cm) | The Jack and Belle Linsky Collection, 1982 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/207107 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
118118 | 118118 | 1982.60.221 | 0 | 1 | 207110 | European Sculpture and Decorative Arts 3 | Figure 9 | Miner | Danish, Copenhagen 2273 | Factory 328 | Royal Porcelain Manufactory | Danish, 1775–present | Royal Porcelain Manufactory 8169 | Danish 144 | 1775 | 9999 | ca. 1787 | 1782 | 1792 | Hard-paste porcelain 572 | Height: 6 1/16 in. (15.4 cm) | The Jack and Belle Linsky Collection, 1982 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/207110 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
118234 | 118234 | 1982.60.350 | 0 | 1 | 207227 | European Sculpture and Decorative Arts 3 | Snuffbox 818 | Snuffbox | possibly Danish, Copenhagen 3366 | Factory 328 | Royal Porcelain Manufactory | Danish, 1775–present | (?) | Royal Porcelain Manufactory 8169 | Danish 144 | 1775 | 9999 | ca. 1775 | 1770 | 1780 | Hard-paste porcelain, gilt-metal 23529 | Diameter: 2 3/8 in. (6 cm) | The Jack and Belle Linsky Collection, 1982 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/207227 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
119457 | 119457 | 1995.268.323 | 0 | 1 | 208493 | European Sculpture and Decorative Arts 3 | Tray 768 | Tray | Danish, Copenhagen 2273 | Factory 328 | Royal Porcelain Manufactory | Danish, 1775–present | Royal Porcelain Manufactory 8169 | Danish 144 | 1775 | 9999 | 1780–90 | 1780 | 1790 | Hard-paste porcelain 572 | Length: 16 3/4 in. (42.5 cm) | The Hans Syz Collection, Gift of Stephan B. Syz and John D. Syz, 1995 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/208493 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 |
JSON shape: default, array, newline-delimited
CREATE TABLE "MetObjects" ( "Object Number" TEXT, "Is Highlight" INTEGER, "Is Public Domain" INTEGER, "Object ID" INTEGER, "Department" INTEGER, "Object Name" INTEGER, "Title" TEXT, "Culture" INTEGER, "Period" REAL, "Dynasty" INTEGER, "Reign" INTEGER, "Portfolio" INTEGER, "Artist Role" INTEGER, "Artist Prefix" REAL, "Artist Display Name" TEXT, "Artist Display Bio" TEXT, "Artist Suffix" REAL, "Artist Alpha Sort" INTEGER, "Artist Nationality" INTEGER, "Artist Begin Date" TEXT, "Artist End Date" TEXT, "Object Date" TEXT, "Object Begin Date" INTEGER, "Object End Date" INTEGER, "Medium" INTEGER, "Dimensions" TEXT, "Credit Line" TEXT, "Geography Type" INTEGER, "City" INTEGER, "State" INTEGER, "County" INTEGER, "Country" INTEGER, "Region" INTEGER, "Subregion" INTEGER, "Locale" INTEGER, "Locus" INTEGER, "Excavation" INTEGER, "River" INTEGER, "Classification" INTEGER, "Rights and Reproduction" REAL, "Link Resource" TEXT, "Metadata Date" TEXT, "Repository" INTEGER , FOREIGN KEY ("Department") REFERENCES [Department](id), FOREIGN KEY ("Object Name") REFERENCES [Object Name](id), FOREIGN KEY ("Culture") REFERENCES [Culture](id), FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id), FOREIGN KEY ("Reign") REFERENCES [Reign](id), FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id), FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id), FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id), FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id), FOREIGN KEY ("Medium") REFERENCES [Medium](id), FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id), FOREIGN KEY ("City") REFERENCES [City](id), FOREIGN KEY ("State") REFERENCES [State](id), FOREIGN KEY ("County") REFERENCES [County](id), FOREIGN KEY ("Country") REFERENCES [Country](id), FOREIGN KEY ("Region") REFERENCES [Region](id), FOREIGN KEY ("Subregion") REFERENCES [Subregion](id), FOREIGN KEY ("Locale") REFERENCES [Locale](id), FOREIGN KEY ("Locus") REFERENCES [Locus](id), FOREIGN KEY ("Excavation") REFERENCES [Excavation](id), FOREIGN KEY ("River") REFERENCES [River](id), FOREIGN KEY ("Classification") REFERENCES [Classification](id), FOREIGN KEY ("Repository") REFERENCES [Repository](id)); CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department"); CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name"); CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture"); CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty"); CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign"); CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio"); CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role"); CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort"); CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality"); CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium"); CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type"); CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City"); CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State"); CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County"); CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country"); CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region"); CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion"); CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale"); CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus"); CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation"); CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River"); CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification"); CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository"); CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight"); CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain"); CREATE INDEX metobjects_Department ON MetObjects("Department"); CREATE INDEX metobjects_Culture ON MetObjects("Culture"); CREATE INDEX metobjects_Period ON MetObjects("Period"); CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty"); CREATE INDEX metobjects_Medium ON MetObjects("Medium"); CREATE INDEX metobjects_City ON MetObjects("City"); CREATE INDEX metobjects_State ON MetObjects("State"); CREATE INDEX metobjects_County ON MetObjects("County"); CREATE INDEX metobjects_Country ON MetObjects("Country"); CREATE INDEX metobjects_Region ON MetObjects("Region"); CREATE INDEX metobjects_Subregion ON MetObjects("Subregion"); CREATE INDEX metobjects_Locale ON MetObjects("Locale"); CREATE INDEX metobjects_Locus ON MetObjects("Locus"); CREATE INDEX metobjects_Excavation ON MetObjects("Excavation"); CREATE INDEX metobjects_River ON MetObjects("River");